package com.yjd.bi.etl.sql;

import com.yjd.bi.comm.utils.DbNameUtils;

/**
 * 流失用户数相关SQL
 */
public class LossUserSqlConstants {

    //插入流失用户数据
    public final static String INSERT_LOSS_USER_SUM_DATA = "INSERT INTO " + DbNameUtils.get("yjd_user_loss") + " (date, amount) VALUES (?, ?)";

    //查询最新统计日期
    public final static String LOSS_USER_STATISTICS_MAXDATE = "SELECT MAX(date) AS maxDate FROM " + DbNameUtils.get("yjd_user_loss");

}
